select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Muti-Colored Ruched Quince Party Dress with Hand Made Flowers
Colorful Multi-tiered Quinceanera Party Dress with Appliques
Strapless Baby Blue Dresses for 15 with Colorful Hand Made Flowers
Beading Multi-colored Quinceanera Party Dress with One Shoulder
Beading Ruffled Colorful Dress for Quince with One Shoulder Plus
Appliqued Strapless Green Dresses 15 with Ruffles Custom Made
Popular Two-toned Ruffled Quinceanera Dresses with Appliques
Purple Taffeta Strapless Sweet 16 Dresses with Appliques and Tiers
Lovely Ruffled Strapless Multi-colored Dresses for 15 with Ribbon
Strapless Eggplant Beading Appliqued Dresses Quince with Pleats
Ruffled Beading Colorful Quinceanera Dresses with Pick-ups
Chic Colorful Ruffled Sweet Sixteen Dresses with Beads Decorate
Halter Ruched Blue and White Sweet 16 Dresses with Sequins
Pleated Baby Pink Ruched Quinces Dresses with Hand Made Flower
Beautiful Beading Hot Pink Organza Quince Dresses with Ruffles
Multi-tiered Grass Green Quinceanera Dresses with Leopard Patterns
Beading Appliqued Turquoise Sweet 16 Dresses with Pick-ups
Embroidery Spring Green and White Quince Dress with Pick-ups
Appliqued Red Ruched Bodice Dress for Sweet 16 with Ruffles
Lovely Organza Pleated Sweet 16 Dresses Custom Made
Leopard Print and Organza Ruffles Sweet Sixteen Dress in Lilac
Colorful Sweetheart Dresses Quinceanera with Ruffles Appliques
Appliqued and Ruched Lemon Green Quinceanera Dress Gown Ruffles
Beading and Ruffles Accent Multi-Colored Quinceanera Dress Gown
Green and Blue Halter Beaded and Ruffled Quinceanera Dress Gown
Beaded and Ruched Strapless Blue and Black Dress 15 with Ruffles
Embroidery and Pick ups Accent Green Taffeta Dresses for 15
Appliqued and Ruched Dress for A Quinceanera in Light Blue
Ruffles and Appliques Accent Sweet Sixteen Dress in Multiple Colors
Spring Green and Black Tulle Sweet 15 Dresses with Beading 2013